Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	4357
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	544.6 KiB
Average record size in memory	128.0 B

Variable types

Numeric	15

Alerts

`revenue_purc` is highly overall correlated with `volume_products_purc` and 6 other fields	High correlation
`recency_days` is highly overall correlated with `purchases` and 1 other fields	High correlation
`volume_products_purc` is highly overall correlated with `revenue_purc` and 6 other fields	High correlation
`assort_products_purc` is highly overall correlated with `revenue_purc` and 5 other fields	High correlation
`purchases` is highly overall correlated with `revenue_purc` and 6 other fields	High correlation
`avg_period_purc` is highly overall correlated with `revenue_purc` and 5 other fields	High correlation
`frequency_purc` is highly overall correlated with `recency_days` and 2 other fields	High correlation
`volume_basket_size_purc` is highly overall correlated with `revenue_purc` and 3 other fields	High correlation
`assort_basket_size_purc` is highly overall correlated with `assort_products_purc`	High correlation
`avg_ticket_purc` is highly overall correlated with `revenue_purc` and 3 other fields	High correlation
`returns` is highly overall correlated with `volume_products_ret` and 1 other fields	High correlation
`volume_products_ret` is highly overall correlated with `returns` and 1 other fields	High correlation
`revenue_ret` is highly overall correlated with `returns` and 1 other fields	High correlation
`revenue_real` is highly overall correlated with `revenue_purc` and 6 other fields	High correlation
`volume_products_purc` is highly skewed (γ1 = 20.43890078)	Skewed
`volume_basket_size_purc` is highly skewed (γ1 = 47.76152942)	Skewed
`avg_ticket_purc` is highly skewed (γ1 = 41.54391694)	Skewed
`volume_products_ret` is highly skewed (γ1 = 45.06522235)	Skewed
`revenue_ret` is highly skewed (γ1 = 52.03122381)	Skewed
`revenue_real` is highly skewed (γ1 = 21.62701738)	Skewed
`customer_id` has unique values	Unique
`returns` has 2824 (64.8%) zeros	Zeros
`volume_products_ret` has 2824 (64.8%) zeros	Zeros
`revenue_ret` has 2824 (64.8%) zeros	Zeros

Reproduction

Analysis started	2023-05-18 21:49:01.014689
Analysis finished	2023-05-18 21:50:06.419263
Duration	1 minute and 5.4 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	4357
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15301.55

Minimum	12346
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	12346
5-th percentile	12615.8
Q1	13815
median	15301
Q3	16779
95-th percentile	17985.2
Maximum	18287
Range	5941
Interquartile range (IQR)	2964

Descriptive statistics

Standard deviation	1721.6046
Coefficient of variation (CV)	0.11251177
Kurtosis	-1.1955146
Mean	15301.55
Median Absolute Deviation (MAD)	1482
Skewness	0.00090465831
Sum	66668854
Variance	2963922.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
13618	1	< 0.1%
13568	1	< 0.1%
12450	1	< 0.1%
15334	1	< 0.1%
17562	1	< 0.1%
17879	1	< 0.1%
16050	1	< 0.1%
15909	1	< 0.1%
16448	1	< 0.1%
Other values (4347)	4347	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%

revenue_purc
Real number (ℝ)

Distinct	4247
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2009.9243

Minimum	0
Maximum	279138.02
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	108.022
Q1	301.84
median	662.08
Q3	1625.05
95-th percentile	5728.268
Maximum	279138.02
Range	279138.02
Interquartile range (IQR)	1323.21

Descriptive statistics

Standard deviation	8885.318
Coefficient of variation (CV)	4.4207226
Kurtosis	491.72801
Mean	2009.9243
Median Absolute Deviation (MAD)	461.98
Skewness	19.610576
Sum	8757240.3
Variance	78948876
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28	0.6%
76.32	4	0.1%
79.2	3	0.1%
440	3	0.1%
35.4	3	0.1%
113.5	3	0.1%
363.65	3	0.1%
324.24	2	< 0.1%
207.5	2	< 0.1%
110.38	2	< 0.1%
Other values (4237)	4304	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
3.75	1	< 0.1%
5.9	1	< 0.1%
6.2	1	< 0.1%
12.75	1	< 0.1%
13.3	1	< 0.1%
15	2	< 0.1%
17	1	< 0.1%
20.8	2	< 0.1%
21.95	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%

recency_days
Real number (ℝ)

Distinct	305
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.157677

Minimum	0
Maximum	400
Zeros	35
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	17
median	51
Q3	148
95-th percentile	318
Maximum	400
Range	400
Interquartile range (IQR)	131

Descriptive statistics

Standard deviation	102.88209
Coefficient of variation (CV)	1.0926575
Kurtosis	0.47470125
Mean	94.157677
Median Absolute Deviation (MAD)	41
Skewness	1.2567747
Sum	410245
Variance	10584.724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	103	2.4%
3	94	2.2%
4	94	2.2%
2	89	2.0%
8	79	1.8%
10	77	1.8%
17	74	1.7%
7	72	1.7%
9	70	1.6%
22	64	1.5%
Other values (295)	3541	81.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35	0.8%
1	103	2.4%
2	89	2.0%
3	94	2.2%
4	94	2.2%
5	48	1.1%
7	72	1.7%
8	79	1.8%
9	70	1.6%
10	77	1.8%

Value	Count	Frequency (%)
400	28	0.6%
373	17	0.4%
372	17	0.4%
371	6	0.1%
369	3	0.1%
368	5	0.1%
367	5	0.1%
366	10	0.2%
365	10	0.2%
364	6	0.1%

volume_products_purc
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1771
Distinct (%)	40.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1183.1708

Minimum	0
Maximum	196844
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	43
Q1	157
median	375
Q3	985
95-th percentile	3545.2
Maximum	196844
Range	196844
Interquartile range (IQR)	828

Descriptive statistics

Standard deviation	5030.4692
Coefficient of variation (CV)	4.2516848
Kurtosis	613.01191
Mean	1183.1708
Median Absolute Deviation (MAD)	275
Skewness	20.438901
Sum	5155075
Variance	25305620
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28	0.6%
88	19	0.4%
120	17	0.4%
84	16	0.4%
128	15	0.3%
144	15	0.3%
72	15	0.3%
146	15	0.3%
106	14	0.3%
150	14	0.3%
Other values (1761)	4189	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
1	2	< 0.1%
2	6	0.1%
3	3	0.1%
4	7	0.2%
5	3	0.1%
6	3	0.1%
7	1	< 0.1%
8	1	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%

assort_products_purc
Real number (ℝ)

Distinct	340
Distinct (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.039247

Minimum	0
Maximum	1785
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	15
median	35
Q3	77
95-th percentile	204
Maximum	1785
Range	1785
Interquartile range (IQR)	62

Descriptive statistics

Standard deviation	85.216252
Coefficient of variation (CV)	1.3960895
Kurtosis	99.712864
Mean	61.039247
Median Absolute Deviation (MAD)	24
Skewness	6.9143595
Sum	265948
Variance	7261.8095
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	94	2.2%
10	86	2.0%
8	79	1.8%
9	79	1.8%
11	78	1.8%
13	77	1.8%
15	75	1.7%
5	74	1.7%
7	73	1.7%
6	72	1.7%
Other values (330)	3570	81.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
1	94	2.2%
2	51	1.2%
3	61	1.4%
4	52	1.2%
5	74	1.7%
6	72	1.7%
7	73	1.7%
8	79	1.8%
9	79	1.8%

Value	Count	Frequency (%)
1785	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%
816	1	< 0.1%
717	1	< 0.1%
713	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

purchases
Real number (ℝ)

Distinct	58
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.2210236

Minimum	0
Maximum	206
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	13
Maximum	206
Range	206
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.6220428
Coefficient of variation (CV)	1.8057333
Kurtosis	244.6913
Mean	4.2210236
Median Absolute Deviation (MAD)	1
Skewness	11.955694
Sum	18391
Variance	58.095536
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1505	34.5%
2	827	19.0%
3	501	11.5%
4	395	9.1%
5	236	5.4%
6	173	4.0%
7	139	3.2%
8	98	2.2%
9	69	1.6%
10	54	1.2%
Other values (48)	360	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
1	1505	34.5%
2	827	19.0%
3	501	11.5%
4	395	9.1%
5	236	5.4%
6	173	4.0%
7	139	3.2%
8	98	2.2%
9	69	1.6%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%

avg_period_purc
Real number (ℝ)

Distinct	1155
Distinct (%)	26.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	195.66201

Minimum	1
Maximum	400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	48
median	109.66667
Q3	400
95-th percentile	400
Maximum	400
Range	399
Interquartile range (IQR)	352

Descriptive statistics

Standard deviation	163.38709
Coefficient of variation (CV)	0.83504762
Kurtosis	-1.7281078
Mean	195.66201
Median Absolute Deviation (MAD)	85.333333
Skewness	0.33140981
Sum	852499.38
Variance	26695.343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	1585	36.4%
70	21	0.5%
46	18	0.4%
55	17	0.4%
49	16	0.4%
31	16	0.4%
91	16	0.4%
21	15	0.3%
35	15	0.3%
42	15	0.3%
Other values (1145)	2623	60.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.2%
2	4	0.1%
2.88372093	1	< 0.1%
3	6	0.1%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	4	0.1%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
400	1585	36.4%
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	< 0.1%
356	1	< 0.1%
355	2	< 0.1%
352	1	< 0.1%
351	2	< 0.1%

frequency_purc
Real number (ℝ)

Distinct	1222
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.024340246

Minimum	0
Maximum	1
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0032051282
Q1	0.0076045627
median	0.014705882
Q3	0.026865672
95-th percentile	0.069663795
Maximum	1
Range	1
Interquartile range (IQR)	0.019261109

Descriptive statistics

Standard deviation	0.041207855
Coefficient of variation (CV)	1.6929926
Kurtosis	179.9869
Mean	0.024340246
Median Absolute Deviation (MAD)	0.0084165742
Skewness	10.308712
Sum	106.05045
Variance	0.0016980873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01851851852	33	0.8%
0	28	0.6%
0.05263157895	25	0.6%
0.01612903226	24	0.6%
0.01538461538	24	0.6%
0.03846153846	22	0.5%
0.01639344262	22	0.5%
0.015625	22	0.5%
0.04545454545	21	0.5%
0.025	20	0.5%
Other values (1212)	4116	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
0.002673796791	16	0.4%
0.002680965147	16	0.4%
0.002688172043	6	0.1%
0.002702702703	2	< 0.1%
0.0027100271	5	0.1%
0.002717391304	5	0.1%
0.00272479564	9	0.2%
0.002732240437	10	0.2%
0.002739726027	6	0.1%

Value	Count	Frequency (%)
1	2	< 0.1%
0.550802139	1	< 0.1%
0.5294117647	1	< 0.1%
0.5	4	0.1%
0.4	1	< 0.1%
0.3333333333	4	0.1%
0.3315508021	1	< 0.1%
0.3157894737	1	< 0.1%
0.2727272727	2	< 0.1%
0.2621621622	1	< 0.1%

volume_basket_size_purc
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2136
Distinct (%)	49.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	254.70335

Minimum	0
Maximum	74215
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	32
Q1	92
median	161
Q3	272
95-th percentile	600
Maximum	74215
Range	74215
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	1313.1896
Coefficient of variation (CV)	5.1557611
Kurtosis	2513.3345
Mean	254.70335
Median Absolute Deviation (MAD)	82
Skewness	47.761529
Sum	1109742.5
Variance	1724467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28	0.6%
100	19	0.4%
88	18	0.4%
120	18	0.4%
73	17	0.4%
82	17	0.4%
136	17	0.4%
114	16	0.4%
60	16	0.4%
72	16	0.4%
Other values (2126)	4175	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
1	3	0.1%
2	5	0.1%
3	3	0.1%
3.333333333	1	< 0.1%
4	7	0.2%
5	3	0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	3	0.1%

Value	Count	Frequency (%)
74215	1	< 0.1%
40498.5	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%
4280	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
3028	1	< 0.1%

assort_basket_size_purc
Real number (ℝ)

Distinct	941
Distinct (%)	21.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.683717

Minimum	0
Maximum	259
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1.852381
Q1	7.6666667
median	14
Q3	24
95-th percentile	51.1
Maximum	259
Range	259
Interquartile range (IQR)	16.333333

Descriptive statistics

Standard deviation	17.599326
Coefficient of variation (CV)	0.94196064
Kurtosis	21.356905
Mean	18.683717
Median Absolute Deviation (MAD)	7.5
Skewness	3.2028354
Sum	81404.956
Variance	309.73628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	93	2.1%
10	90	2.1%
8	89	2.0%
9	89	2.0%
7	85	2.0%
13	85	2.0%
6	81	1.9%
11	78	1.8%
5	77	1.8%
14	75	1.7%
Other values (931)	3515	80.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.3%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
219	1	< 0.1%
177	1	< 0.1%
171	1	< 0.1%
155	1	< 0.1%
153	1	< 0.1%
148	2	< 0.1%
141	1	< 0.1%
131	1	< 0.1%
128	1	< 0.1%

avg_ticket_purc
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	4254
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	414.41346

Minimum	0
Maximum	84236.25
Zeros	28
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	84.760667
Q1	176.68
median	289.24
Q3	424.254
95-th percentile	916.94
Maximum	84236.25
Range	84236.25
Interquartile range (IQR)	247.574

Descriptive statistics

Standard deviation	1796.467
Coefficient of variation (CV)	4.3349629
Kurtosis	1855.0399
Mean	414.41346
Median Absolute Deviation (MAD)	120.84
Skewness	41.543917
Sum	1805599.4
Variance	3227293.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28	0.6%
76.32	4	0.1%
120	3	0.1%
79.2	3	0.1%
440	3	0.1%
35.4	3	0.1%
113.5	3	0.1%
114.56	2	< 0.1%
179	2	< 0.1%
594	2	< 0.1%
Other values (4244)	4304	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28	0.6%
3.75	1	< 0.1%
5.9	1	< 0.1%
6.2	1	< 0.1%
9.14	1	< 0.1%
11.67	1	< 0.1%
12.75	1	< 0.1%
13.3	1	< 0.1%
15	2	< 0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
84236.25	1	< 0.1%
77183.6	1	< 0.1%
14844.76667	1	< 0.1%
13305.5	1	< 0.1%
9341.26	1	< 0.1%
6228.2265	1	< 0.1%
6207.67	1	< 0.1%
4873.81	1	< 0.1%
4366.78	1	< 0.1%
4327.621667	1	< 0.1%

returns
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.77622217

Minimum	0
Maximum	45
Zeros	2824
Zeros (%)	64.8%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.965778
Coefficient of variation (CV)	2.532494
Kurtosis	152.4758
Mean	0.77622217
Median Absolute Deviation (MAD)	0
Skewness	9.1990888
Sum	3382
Variance	3.864283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	2824	64.8%
1	875	20.1%
2	292	6.7%
3	140	3.2%
4	92	2.1%
5	37	0.8%
6	32	0.7%
7	21	0.5%
9	8	0.2%
11	5	0.1%
Other values (13)	31	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2824	64.8%
1	875	20.1%
2	292	6.7%
3	140	3.2%
4	92	2.1%
5	37	0.8%
6	32	0.7%
7	21	0.5%
8	5	0.1%
9	8	0.2%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	5	0.1%

volume_products_ret
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	218
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.850356

Minimum	0
Maximum	80995
Zeros	2824
Zeros (%)	64.8%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	60
Maximum	80995
Range	80995
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1685.8517
Coefficient of variation (CV)	27.256944
Kurtosis	2079.0948
Mean	61.850356
Median Absolute Deviation (MAD)	0
Skewness	45.065222
Sum	269482
Variance	2842095.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2824	64.8%
1	175	4.0%
2	152	3.5%
3	105	2.4%
4	91	2.1%
6	79	1.8%
5	64	1.5%
12	55	1.3%
7	44	1.0%
8	43	1.0%
Other values (208)	725	16.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2824	64.8%
1	175	4.0%
2	152	3.5%
3	105	2.4%
4	91	2.1%
5	64	1.5%
6	79	1.8%
7	44	1.0%
8	43	1.0%
9	42	1.0%

Value	Count	Frequency (%)
80995	1	< 0.1%
74215	1	< 0.1%
9360	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3331	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%

revenue_ret
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1102
Distinct (%)	25.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.88107

Minimum	0
Maximum	168469.6
Zeros	2824
Zeros (%)	64.8%
Negative	0
Negative (%)	0.0%
Memory size	68.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	15
95-th percentile	150.4
Maximum	168469.6
Range	168469.6
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	2850.4684
Coefficient of variation (CV)	26.17965
Kurtosis	2918.7792
Mean	108.88107
Median Absolute Deviation (MAD)	0
Skewness	52.031224
Sum	474394.83
Variance	8125170.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2824	64.8%
12.75	20	0.5%
4.95	19	0.4%
9.95	17	0.4%
15	17	0.4%
5.9	12	0.3%
25.5	11	0.3%
3.75	10	0.2%
4.25	10	0.2%
7.5	9	0.2%
Other values (1092)	1408	32.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2824	64.8%
0.42	2	< 0.1%
0.65	1	< 0.1%
0.95	1	< 0.1%
1.25	5	0.1%
1.45	4	0.1%
1.64	1	< 0.1%
1.65	5	0.1%
1.7	2	< 0.1%
1.79	1	< 0.1%

Value	Count	Frequency (%)
168469.6	1	< 0.1%
77183.6	1	< 0.1%
22998.4	1	< 0.1%
14688.24	1	< 0.1%
8511.15	1	< 0.1%
7393.59	1	< 0.1%
5228.4	1	< 0.1%
4815.26	1	< 0.1%
4814.74	1	< 0.1%
4486.24	1	< 0.1%

revenue_real
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	4273
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1901.0433

Minimum	-1192.2
Maximum	278778.02
Zeros	10
Zeros (%)	0.2%
Negative	30
Negative (%)	0.7%
Memory size	68.1 KiB

Quantile statistics

Minimum	-1192.2
5-th percentile	101.94
Q1	294.12
median	645.72
Q3	1598.24
95-th percentile	5630.694
Maximum	278778.02
Range	279970.22
Interquartile range (IQR)	1304.12

Descriptive statistics

Standard deviation	8270.8593
Coefficient of variation (CV)	4.3506949
Kurtosis	603.42176
Mean	1901.0433
Median Absolute Deviation (MAD)	451.35
Skewness	21.627017
Sum	8282845.5
Variance	68407113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	0.2%
76.32	4	0.1%
15	3	0.1%
79.2	3	0.1%
113.5	3	0.1%
363.65	3	0.1%
440	3	0.1%
35.4	3	0.1%
59.5	2	< 0.1%
174.37	2	< 0.1%
Other values (4263)	4321	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1192.2	1	< 0.1%
-811.86	1	< 0.1%
-464.9	1	< 0.1%
-295.09	1	< 0.1%
-227.44	1	< 0.1%
-152.64	1	< 0.1%
-141.48	1	< 0.1%
-134.8	1	< 0.1%
-102.45	1	< 0.1%
-102	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
128882.13	1	< 0.1%
123638.18	1	< 0.1%
113855.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

Auto

Heatmap
Table

	customer_id	revenue_purc	recency_days	volume_products_purc	assort_products_purc	purchases	avg_period_purc	frequency_purc	volume_basket_size_purc	assort_basket_size_purc	avg_ticket_purc	returns	volume_products_ret	revenue_ret	revenue_real
customer_id	1.000	-0.081	0.008	-0.072	-0.009	0.000	0.005	0.012	-0.107	-0.009	-0.128	-0.045	-0.052	-0.048	-0.076
revenue_purc	-0.081	1.000	-0.494	0.931	0.734	0.811	-0.676	0.460	0.572	0.151	0.682	0.482	0.469	0.469	0.992
recency_days	0.008	-0.494	1.000	-0.497	-0.467	-0.572	0.477	-0.790	-0.178	-0.032	-0.145	-0.253	-0.237	-0.236	-0.496
volume_products_purc	-0.072	0.931	-0.497	1.000	0.732	0.764	-0.636	0.469	0.723	0.191	0.627	0.444	0.437	0.428	0.926
assort_products_purc	-0.009	0.734	-0.467	0.732	1.000	0.662	-0.536	0.418	0.438	0.612	0.429	0.352	0.331	0.330	0.740
purchases	0.000	0.811	-0.572	0.764	0.662	1.000	-0.851	0.528	0.154	-0.121	0.172	0.478	0.454	0.454	0.810
avg_period_purc	0.005	-0.676	0.477	-0.636	-0.536	-0.851	1.000	-0.570	-0.120	0.130	-0.132	-0.387	-0.369	-0.369	-0.675
frequency_purc	0.012	0.460	-0.790	0.469	0.418	0.528	-0.570	1.000	0.175	-0.005	0.139	0.253	0.236	0.235	0.463
volume_basket_size_purc	-0.107	0.572	-0.178	0.723	0.438	0.154	-0.120	0.175	1.000	0.449	0.816	0.167	0.182	0.166	0.569
assort_basket_size_purc	-0.009	0.151	-0.032	0.191	0.612	-0.121	0.130	-0.005	0.449	1.000	0.418	-0.075	-0.077	-0.079	0.160
avg_ticket_purc	-0.128	0.682	-0.145	0.627	0.429	0.172	-0.132	0.139	0.816	0.418	1.000	0.223	0.228	0.227	0.675
returns	-0.045	0.482	-0.253	0.444	0.352	0.478	-0.387	0.253	0.167	-0.075	0.223	1.000	0.973	0.976	0.455
volume_products_ret	-0.052	0.469	-0.237	0.437	0.331	0.454	-0.369	0.236	0.182	-0.077	0.228	0.973	1.000	0.989	0.434
revenue_ret	-0.048	0.469	-0.236	0.428	0.330	0.454	-0.369	0.235	0.166	-0.079	0.227	0.976	0.989	1.000	0.433
revenue_real	-0.076	0.992	-0.496	0.926	0.740	0.810	-0.675	0.463	0.569	0.160	0.675	0.455	0.434	0.433	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	revenue_purc	recency_days	volume_products_purc	assort_products_purc	purchases	avg_period_purc	frequency_purc	volume_basket_size_purc	assort_basket_size_purc	avg_ticket_purc	returns	volume_products_ret	revenue_ret	revenue_real
0	17850	5391.210	372.000	1733.000	21.000	34.000	1.000	0.091	50.971	0.618	158.565	1.000	40.000	102.580	5288.630
1	13047	3232.590	56.000	1390.000	105.000	9.000	52.833	0.024	154.444	11.667	359.177	7.000	35.000	143.490	3089.100
2	12583	6705.380	2.000	5028.000	114.000	15.000	26.500	0.040	335.200	7.600	447.025	2.000	50.000	76.040	6629.340
3	13748	948.250	95.000	439.000	24.000	5.000	92.667	0.013	87.800	4.800	189.650	0.000	0.000	0.000	948.250
4	15100	876.000	333.000	80.000	1.000	3.000	20.000	0.008	26.667	0.333	292.000	3.000	22.000	240.900	635.100
5	15291	4623.300	25.000	2102.000	61.000	14.000	26.769	0.037	150.143	4.357	330.236	5.000	29.000	71.790	4551.510
6	14688	5630.870	7.000	3621.000	148.000	21.000	19.263	0.056	172.429	7.048	268.137	6.000	399.000	523.490	5107.380
7	17809	5411.910	16.000	2057.000	46.000	12.000	39.667	0.032	171.417	3.833	450.993	2.000	41.000	67.060	5344.850
8	15311	60767.900	0.000	38194.000	567.000	91.000	4.191	0.243	419.714	6.231	667.779	27.000	474.000	1348.560	59419.340
9	16098	2005.630	87.000	613.000	34.000	7.000	47.667	0.019	87.571	4.857	286.519	0.000	0.000	0.000	2005.630

	customer_id	revenue_purc	recency_days	volume_products_purc	assort_products_purc	purchases	avg_period_purc	frequency_purc	volume_basket_size_purc	assort_basket_size_purc	avg_ticket_purc	returns	volume_products_ret	revenue_ret	revenue_real
4347	16000	12393.700	2.000	5110.000	9.000	3.000	400.000	1.000	1703.333	3.000	4131.233	0.000	0.000	0.000	12393.700
4348	15195	3861.000	2.000	1404.000	1.000	1.000	400.000	0.333	1404.000	1.000	3861.000	0.000	0.000	0.000	3861.000
4349	14087	194.420	2.000	251.000	61.000	1.000	400.000	0.333	251.000	61.000	194.420	1.000	1.000	12.750	181.670
4350	14204	161.030	2.000	82.000	36.000	1.000	400.000	0.333	82.000	36.000	161.030	0.000	0.000	0.000	161.030
4351	15471	469.480	2.000	266.000	67.000	1.000	400.000	0.333	266.000	67.000	469.480	0.000	0.000	0.000	469.480
4352	13436	196.890	1.000	76.000	12.000	1.000	400.000	0.500	76.000	12.000	196.890	0.000	0.000	0.000	196.890
4353	15520	343.500	1.000	314.000	18.000	1.000	400.000	0.500	314.000	18.000	343.500	0.000	0.000	0.000	343.500
4354	13298	360.000	1.000	96.000	2.000	1.000	400.000	0.500	96.000	2.000	360.000	0.000	0.000	0.000	360.000
4355	14569	227.390	1.000	79.000	10.000	1.000	400.000	0.500	79.000	10.000	227.390	0.000	0.000	0.000	227.390
4356	12713	794.550	0.000	505.000	37.000	1.000	400.000	1.000	505.000	37.000	794.550	0.000	0.000	0.000	794.550

Overview

Variables

Interactions

Correlations

Missing values

Sample